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

Popular posts from this blog

excel vba - How to delete Solver(SOLVER.XLAM) code -

jsp - Google line chart x-axis shrinks on transition -

java - Reaching JTextField in a DocumentListener -