[ACCEPTED]-How to match one character in MySQL in place of %?-mysql

Accepted answer

Score: 53

You want to use an underscore (_) character. See 1 the documentation here.

Score: 20

_ will match exactly one character :

select * from X where Y like "_s"

0

Score: 5

An easy way you can do it if you know the 3 domain of characters to match:

select * from X where Y like '[a-z]s'

or like this

select * from X where Y like '[a-zA-Z0-9]s'

alternatively 2 you could use the _ (underscore) syntax 1 like follows:

select * from X where Y like '_s'

Source: stackoverflow.com

More Related questions

Best way to archive live MySQL database

Foreign keys in MySQL?

Store GUID in MySQL from C#

MySQL backup and restore from command line

Creating your own TinyURL

What is the best way to bind decimal / double / float values with PDO in PHP?

Unique constraint that allows empty values in MySQL

Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?

How do I view the warning(s) after a SELECT query using the MySQL command line?

MySQL remove duplicates from big database quick

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.