Wildcard problem

0 Edwin Cullen · April 2, 2015
The query:

SELECT * FROM customers WHERE address LIKE '____ _ ____ st'

In the above query the sequence before "st" is as follows:

Underscore-Underscore-Underscore-Underscore-Space-Underscore-Space-Underscore-Underscore-Underscore-Underscore.

As it was told in tutorial 14 of MySQL Database, each underscore is for one character. Accordingly, I should the get the results which follows above query, but I am getting nothing.

See the picture below. Note that the result shown in the picture is not for given query.

/images/forum/upload/2015-04-02/3e742b7c417844dec64d677b98425a42.jpg

Post a Reply

Replies

Oldest  Newest  Rating
0 mike richardson · April 7, 2015
LIKE '____ _ ____ st%'
  • 1

SQL & Databases

107,276 followers
About

Everything SQL and Databases related in here!

Links
Moderators
Bucky Roberts Administrator