Sergy Stouk
asked on
MySQL Query
I have MySQL table with the listing of the file names.
When Searching for rows, with the query:
WHERE f_name LIKE '%integral parts of%'
the result is zero rows found.
When searching for
WHERE f_name LIKE '%integral part% of%'
it returns all the file names, containing the searched element. with
'integral parts of'
Is the word 'parts' a special word that cannot be used in MySQL query?
At least it looks like it.
What other words cannot be used in the search?
Thank You.
When Searching for rows, with the query:
WHERE f_name LIKE '%integral parts of%'
the result is zero rows found.
When searching for
WHERE f_name LIKE '%integral part% of%'
it returns all the file names, containing the searched element. with
'integral parts of'
Is the word 'parts' a special word that cannot be used in MySQL query?
At least it looks like it.
What other words cannot be used in the search?
Thank You.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.