Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Finding out if a varchar contains a percent sign, in MySQL

Tags:

mysql

Can't find an answer to this...

How can I select rows where a certain column (varchar) contains a percent sign (%), in MySQL ?

like image 906
julien_c Avatar asked Mar 30 '11 17:03

julien_c

1 Answers

where col like '%|%%' escape '|'
like image 179
RichardTheKiwi Avatar answered Sep 29 '22 07:09

RichardTheKiwi
Sign in to Comment

Related questions

MySQL concat() to create column names to be used in a query?
How to backup whole MySQL database with all users and permissions and passwords?
What does "SELECT /*!N SQL_NO_CACHE */ * FROM `mytable`" mean in in MySQL's slow query log?
How to select a maximum value row in mysql table
Column 'user_id' in field list is ambiguous
Big integer field in django models
MySQL explain for DELETE queries
How to remove part of string in mysql?
In mysql, the show databases; command doesn't list all of my databases
select users have more than one distinct records in mysql
Creating MYSQL Procedure in Laravel 4 Migrations
Ruby on Rails cannot connect to mysql database
How do I convert an Error object in node js to a string properly?
dyld: Library not loaded: /usr/local/opt/unixodbc/lib/libodbc.2.dylib
Ping a MySQL server
Context manager for Python's MySQLdb
Foreign key that can also be zero
Execute triggers stored procedures on SqlFiddle. Mysql
MySQL - Fetch rows where a field value is less than 5 chars
Alter a live table to make a key non-unique

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!