• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

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.
0
sstouk
Asked:
sstouk
1 Solution
 
rugdogCommented:
sstouk,
  try:

WHERE f_name LIKE '%integral parts%of%'

my guess is that the strings in the table contain a character different from regular blank space after 'parts' (maybe a tab).

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now