Click here to Skip to main content
16,012,316 members

Comments by Chui PuiKwan (Top 27 by date)

Chui PuiKwan 26-Jul-13 3:11am View    
mysql> select INSTR('2013/19/12','19/') >0;
+------------------------------+
| INSTR('2013/19/12','19/') >0 |
+------------------------------+
| 1 |
+------------------------------+
1 row in set

mysql> select INSTR('2013-12-12','19/');>0
+---------------------------+
| INSTR('2013-12-12','19/') |
+---------------------------+
| 0 |
+---------------------------+
1 row in set

That INSTR(date,'19/')>0 indicate that the date contains 19/
Chui PuiKwan 26-Jul-13 3:03am View    
mysql> select
INSTR('2013-12-12','19/');
+---------------------------+
| INSTR('2013-12-12','19/') |
+---------------------------+
| 0 |
+---------------------------+
1 row in set
mysql> select INSTR('2013/19/12
','19/');
+---------------------------+
| INSTR('2013/19/12','19/') |
+---------------------------+
| 6 |
+---------------------------+
1 row in set
Chui PuiKwan 26-Jul-13 2:52am View    
Sorry,it's a wide range of requirements.
I wish you can list them more clearly.
Only you konw what you want to do very clearly ,you could done it very well .
Chui PuiKwan 26-Jul-13 2:48am View    
puikwanchui@gmail.com
Chui PuiKwan 26-Jul-13 2:48am View    
If you could give me a demo data, I can help you to debug it .