MySQL Full-Text BOOLEAN mode

Published on Tue Mar 01 2022

Checks if an input string is compatible with the BOOLEAN mode of MySQL full text search system

Additional matching regexes for
MySQL Full-Text BOOLEAN mode

MySQL Full-Text BOOLEAN mode

Checks if an input string is compatible with the BOOLEAN mode of MySQL full text search system

MySQL PHP connection string

Capture dbname and host from MySQL PHP connection string

email check

checks the email string for valid

Parse CSV fields

Parse an input string into fields separated by comma.

MySql Definer

For find definer in mysql routines

MySQLcase

make sure mysql tables have the correct form

search text matching any word

search text matching any word

search word with an accent

search any word with an accent

Convert YYMMDD to DD/MM/YY

I'm new to regular expressions and I've been searching high and low for this really simple date conversion from YYMMDD to DD/MM/YY e.g. 140923 to 23/09/14. Maybe I just didn't search hard enough, but here goes: Search/original string: (\d{4})(\d{2})(\d{2}) Replace string $3/$2/$1

salary

Chinese salary input