Approach

For each row in the Samples table, check:
- If dna_sequence starts with 'ATG'.
- If dna_sequence ends with 'TAA', 'TAG', or 'TGA'.
- If dna_sequence contains 'ATAT'.
- If dna_sequence contains at least three consecutive 'G's.
Output the required columns and computed flags, ordered by sample_id ascending.

Code

[{"language":"MySQL","code":"SELECT\n  sample_id,\n  dna_sequence,\n  species,\n  (dna_sequence LIKE 'ATG%') AS has_start,\n  (dna_sequence LIKE '%TAA' OR dna_sequence LIKE '%TAG' OR dna_sequence LIKE '%TGA') AS has_stop,\n  (dna_sequence LIKE '%ATAT%') AS has_atat,\n  (dna_sequence REGEXP 'GGG') AS has_ggg\nFROM Samples\nORDER BY sample_id ASC;","lang":"sql","html":"<pre class=\"shiki shiki-themes github-light github-dark\" style=\"background-color:#fff;--shiki-dark-bg:#24292e;color:#24292e;--shiki-dark:#e1e4e8\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color:#D73A49;--shiki-dark:#F97583\">SELECT</span></span>\n<span class=\"line\"><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">  sample_id,</span></span>\n<span class=\"line\"><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">  dna_sequence,</span></span>\n<span class=\"line\"><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">  species,</span></span>\n<span class=\"line\"><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">  (dna_sequence </span><span style=\"color:#D73A49;--shiki-dark:#F97583\">LIKE</span><span style=\"color:#032F62;--shiki-dark:#9ECBFF\"> 'ATG%'</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">) </span><span style=\"color:#D73A49;--shiki-dark:#F97583\">AS</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\"> has_start,</span></span>\n<span class=\"line\"><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">  (dna_sequence </span><span style=\"color:#D73A49;--shiki-dark:#F97583\">LIKE</span><span style=\"color:#032F62;--shiki-dark:#9ECBFF\"> '%TAA'</span><span style=\"color:#D73A49;--shiki-dark:#F97583\"> OR</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\"> dna_sequence </span><span style=\"color:#D73A49;--shiki-dark:#F97583\">LIKE</span><span style=\"color:#032F62;--shiki-dark:#9ECBFF\"> '%TAG'</span><span style=\"color:#D73A49;--shiki-dark:#F

Related Tags