1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
| --------------
SET AUTOCOMMIT = 0
--------------
--------------
START TRANSACTION
--------------
--------------
DROP DATABASE IF EXISTS `base`
--------------
--------------
CREATE DATABASE `base`
DEFAULT CHARACTER SET `latin1`
DEFAULT COLLATE `latin1_general_ci`
--------------
--------------
DROP TABLE IF EXISTS `test`
--------------
--------------
CREATE TABLE `test`
(
`id` integer unsigned NOT NULL AUTO_INCREMENT Primary Key,
`champs` varchar(255) NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=`latin1` COLLATE=`latin1_general_ci`
ROW_FORMAT=COMPRESSED
--------------
--------------
INSERT INTO `test` (`champs`) VALUES
('jean françois'),
('MOZART Wolfgang Amadeus'),
('de la Halle Adam')
--------------
--------------
select * from test
--------------
+----+-------------------------+
| id | champs |
+----+-------------------------+
| 1 | jean françois |
| 2 | MOZART Wolfgang Amadeus |
| 3 | de la Halle Adam |
+----+-------------------------+
--------------
select concat('-->',
reverse(substr(reverse(champs), 1, locate(' ', reverse(champs))-1)), ' ',
reverse(substr(reverse(champs), locate(' ', reverse(champs))+1)),
'<--') as 'résultat 1'
from test
--------------
+-------------------------------+
| résultat 1 |
+-------------------------------+
| -->françois jean<-- |
| -->Amadeus MOZART Wolfgang<-- |
| -->Adam de la Halle<-- |
+-------------------------------+
--------------
select concat('-->',
substr(champs, locate(' ', champs)+1), ' ',
substr(champs, 1, locate(' ', champs)-1),
'<--') as 'résultat 2'
from test
--------------
+-------------------------------+
| résultat 2 |
+-------------------------------+
| -->françois jean<-- |
| -->Wolfgang Amadeus MOZART<-- |
| -->la Halle Adam de<-- |
+-------------------------------+
--------------
COMMIT
--------------
--------------
SET AUTOCOMMIT = 1
--------------
Appuyez sur une touche pour continuer... |
Partager