pastebin 3.0 BETA

view entry

Information

Title:
concat_ws, regexp & dates Description:
If I try to search in a string (concat_ws out) with dates, regexp doesn't run fine. Posted by:
ccosta Added:
04:47:11 on Tuesday, 7th of February, 2006 Source type:
MySQL Number of lines:
14 Number of hits:
31 Options:
Post change or solution to this entry
Copy URL to clipboard
Copy code to clipboard
Download as file Related entries:

"concat_ws, regexp & dates" by ccosta

Comments:
0 (Add / View all) Last 3 comments:
There are no comments for this entry.

Source code

1
2
3
4
5
6
7
8
9
10
11
12
13
14

mysql> select concat_ws(' ','My Master',now()) regexp '[[:<:]]master[[:>:]]' ; +-----------------------------------------------------------------+ | concat_ws(' ','My Master',now()) regexp '[[:<:]]master[[:>:]]' | +-----------------------------------------------------------------+ | 0 | +-----------------------------------------------------------------+ mysql> select 'My Master 2006-02-07 11:47:56' regexp '[[:<:]]master[[:>:]]' ; +----------------------------------------------------------------+ | 'My Master 2006-02-07 11:47:56' regexp '[[:<:]]master[[:>:]]' | +----------------------------------------------------------------+ | 1 | +----------------------------------------------------------------+ 1 row in set (0.00 sec)