Using regular expressions in SQL statements_PHP tutorial

WBOY
Release: 2016-07-13 10:53:32
Original
864 people have browsed it

Yes, this can be achieved using the regexp keyword.
For example: I want to search for records in the admin table where the username field is a number. You can use the following SQL statement:
select * from articles where title regexp '[0-9].+';

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/632398.htmlTechArticleYes, it can be achieved using the regexp keyword. For example: I want to search for records in the admin table where the username field is a number. You can use the following SQL statement: select * from articles whe...
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template