Choosing sql query with value symbol% ​​as value

Question

Hello, I have a table in the database:

╔══════════════════════════════════════════╗ ║ v3_url_alias ║ ╠════╦═══════════════╦═════════════════════╣ ║ id ║ query ║ keyword ║ ╠════╬═══════════════╬═════════════════════╣ ║ 1 ║ product_id=20 ║ 540-65R38-K_028 ║ ║ 2 ║ product_id=21 ║ 18.00R33-EM_DT-150% ║ ╚════╩═══════════════╩═════════════════════╝ 

I use this table to make my URLs friendly, but many people know that the% sign is not a valid URL character, so my browser receives a bad request. I have many records in this table (1700 or so) and need a query to capture all those that have% in the keyword.

So, I tried doing this in MySQL and came up with this query:

 SELECT * FROM v3_url_alias WHERE keyword LIKE '%%%'; 

This returned all my keywords since% is used as a wildcard.

My question is, how to get every keyword containing the% character with SQL?

Answer 1

Use an escape character!

MySQL has a backslash ( \ ) as the default escape character:

 SELECT * FROM v3_url_alias WHERE keyword LIKE '%\%%'; 

ANSI SQL - use the ESCAPE clause to specify an escape character, for example:

 SELECT * FROM v3_url_alias WHERE keyword LIKE '%#%%' escape '#'; 

(This also works with MySQL, at least as long as \ not specified.)

Answer 2

Use square brackets.

 SELECT * FROM v3_url_alias WHERE keyword LIKE '%[%]%' 

Answer 3

Using MySQL:

Use backslash to escape the character (\).

 SELECT * FROM v3_url_alias WHERE keyword LIKE '%\%%';