KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am using MySQL. I have a car table in my database, and there is a name column in that table. Suppose the name column of the table contain values: +----------+ | name | +----------+ | AAA BB | ---------- | CC D BB | ---------- | OO kk BB | ---------- | PP B CC | ---------- I would like to search the table where name column value contains " BB " , What is the SQL command to achieve this ? I tried : SELECT * FROM car WHERE name LIKE "BB"; But it does not work. P.S. The values in name column are random strings. Please do not ask me to use IN (...) , because the values in that column is unpredictable. ---------Please close this question-------------- Sorry, I think I asked the question wrongly. Actually I am asking for a word match not a substring.
Tags (comma-separated)
Save Edits
Cancel