mysql - specific search in database -
I am looking for a method to search specific words in mysql with insodeb engine. Consider the following example:
Text: 1. There are two sides of the card 2. This is my card. 3. We have a car 4. The color of the car is good 5. This was my car. 6. The car is good Suppose these points are separate rows and the same columns are under "text." I need a query that requires the use of the word "cart" to remove rows with the word "word" even if the word "car" starts at the beginning, in the middle, or at the end. Keep in mind that "card" is not required.
Here it is. from SELECT * Name like 'car' or 'name car' or name 'name' or '% car%' like name 'car' name '% car' This word will select between both the word start word and the word
Comments
Post a Comment