Hi,
I want the db to return records which have either "bmw" or "audi". Below is my code but the db only shows records which have bmw.
SELECT * FROM `details` WHERE BRAND = 'bmw' OR 'audi'
Thank you in advance.
Cheers,
Vishal
Hi,
I want the db to return records which have either "bmw" or "audi". Below is my code but the db only shows records which have bmw.
SELECT * FROM `details` WHERE BRAND = 'bmw' OR 'audi'
Thank you in advance.
Cheers,
Vishal
RTFM.
And change your syntax to
SELECT * FROM `details` WHERE BRAND = 'bmw' OR [U]BRAND = [/U]'audi'
thanks smantscheff :)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.