Timeline for Like predicate to match a whole word only
Current License: CC BY-SA 3.0
28 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 15, 2017 at 13:48 | history | edited | Andriy M | CC BY-SA 3.0 |
removed a tag from the title; improved grammar, punctuation
|
| Dec 15, 2017 at 6:54 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 10, 2017 at 14:16 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 10, 2017 at 1:46 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 9, 2017 at 22:23 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 10, 2017 at 16:09 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 9, 2017 at 19:49 | answer | added | joanolo | timeline score: 1 | |
| Jul 9, 2017 at 19:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 7, 2017 at 21:58 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 6, 2017 at 6:11 | comment | added | ypercubeᵀᴹ |
The example is not very good by the way. Both 'Open' and 'Computers' have o and e. Unless you only want lower o (and exclude O) and you want the order to be "first-e-then-o" in the same word (and exclude "first-o-then-e")
|
|
| May 6, 2017 at 5:41 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 3, 2017 at 2:12 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 27, 2017 at 22:57 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 26, 2017 at 19:27 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 14, 2016 at 16:52 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 10, 2016 at 13:36 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 6, 2016 at 19:47 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 5, 2016 at 20:20 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 5, 2016 at 23:58 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 1, 2016 at 15:54 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 31, 2016 at 15:25 | answer | added | Matjaž | timeline score: 0 | |
| Jan 11, 2016 at 11:14 | answer | added | indago | timeline score: -1 | |
| Dec 14, 2015 at 21:19 | history | tweeted | twitter.com/StackDBAs/status/676511888642072577 | ||
| Dec 14, 2015 at 19:27 | comment | added | jkavalik |
Well, the LIKE you showed cannot use index too (only prefix matches can).
|
|
| Dec 14, 2015 at 16:38 | comment | added | Farhad | Thanks for your comment. REGEXP is really powerful and I'm sure it can fulfil my needs but REGEXP can be very expensive because SQL can't use index and queries may need much time to be executed and Our software runs on multi platform (Android & Windows) I hope implementing REGEXP function on them is an easy task. | |
| Dec 13, 2015 at 20:45 | comment | added | jkavalik |
LIKE is not strong enough for this, but you could use REGEXP instead. It seems from the documentation that you have to supply the function yourself, but you will probably be able to find one - some details are in this answer
|
|
| Dec 13, 2015 at 19:00 | review | First posts | |||
| Dec 13, 2015 at 20:31 | |||||
| Dec 13, 2015 at 18:57 | history | asked | Farhad | CC BY-SA 3.0 |